<?php
/**
 * Created by PhpStorm.
 * User: ASUS
 * Date: 2016/10/16
 * Time: 15:13
 */
header('content-type:text/html;charset=utf-8');
require './.idea/public_function.php';

$link=mysqli_connect('localhost','root','');

dbInit();

$fiedles=array('e_dept','date_of_entry');
$sql_order='';

$order=isset($_GET['order']) ? $_GET['order']:'';
$sort=isset($_GET['sort']) ? $_GET['sort']:'';

if($sort=='desc'){
    $sql_order="order by $order desc";
    $sort='asc';
}else{
    $sql_order="order by $order asc";
    $sort='desc';
}
$where='';
if(isset($_GET['keyword'])){
    $keyword=$_GET['keyword'];
    $keyword=mysqli_real_escape_string( $link,$keyword);
    $where="where e_name like '%$keyword%'";
}

$page_size=2;
$result=mysqli_query('select count(*) from `emp_info`');
$count=mysqli_fetch_row($result);
$count=$count[0];
$max_page=ceil($count/$page_size);
$page=isset($_GET['page'])? intval($_GET['page']):1;
$page=$page > $max_page? $max_page :$page;
$page=$page <1 ? 1: $page;

$page=1;
$lim=($page-1)*2;
$sql="select * from`emp_info`limit $lim,2";
$result=mysqli_query($link,$sql);
$page_html="<a href='./showList.php?page=1'>首页</a>&nbsp;";
$page_html.="<a href='./showList.php?page=".(($page - 1) > 0 ? ($page - 1) : 1)."'>上一页</a>&nbsp;";
$page_html.="<a href='./showList.php?page=".(($page + 1)< $max_page ?($page + 1):$max_page)."'>下一页</a>&nbsp;";
$page_html.="<a href='./showList.php?page={$max_page}'>尾页</a>";
$lim=($page-1)*2;



$sql ="select * form `emp_info` $sql_order ";
$result = mysqli_query($link,$sql);
$emp_info=fetchAll($sql);
define('APP','itcast');
require './list_html.php';